cross join (anti)
Short Description
For every row in the left table a cross join will return every row in the right table.
Detailed Description​
Unless there is a matching condition applied, for every row in the left table, a cross Join will return every matching row in the right table.
Anti Joins are used to return rows from the left table (left anti join) that are not present in the right, or to return rows from the right table (right anti join) that are not present in the left.
Additional Links​
- CockroachDB Docs - JOIN expressions
- CockroachDB Docs - Supported Join Algorithms
- CockroachDB Docs - Cost Based Optimizer
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.